The CompileWhenLoaded option is generally used to improve performance. If you enter Yes for this option (the default is No), the system loads and compiles all of the functions in a DAL library file at the beginning of a processing job. There are, however, times when you may not want to do this, such as...
If you are only doing a few transactions at a time. In this case, compiling the functions ahead of time can actually impede performance. While compiling functions ahead of time can save time if you are processing a large number of transactions, if the transaction count is small, you may not gain anything.
If your library contains a large number of functions but very few of them are actually used. It does not improve performance to compile functions you do not use.
If you have a problem in DAL execution, turn off the CompileWhenLoaded option temporarily to help determine if the problem is related to precompiling the scripts. Be sure to include your results when you report the issue.
© Copyright 2018, Oracle and/or its affiliates. All rights reserved. Legal notices.